﻿CREATE TABLE [dbo].[ArticulosDatosAdicionales] (
    [IdArticuloDatoAdicional] INT          IDENTITY (1, 1) NOT NULL,
    [IdArticulo]              INT          NOT NULL,
    [IdTipoDatoAdicional]     TINYINT      NOT NULL,
    [Nombre]                  VARCHAR (50) NOT NULL,
    [EstaEliminado]           BIT          CONSTRAINT [DF_ArticulosDatosAdicionalesNumeros_EstaEliminado] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_ArticulosDatosAdicionales] PRIMARY KEY CLUSTERED ([IdArticuloDatoAdicional] ASC),
    CONSTRAINT [FK_ArticulosDatosAdicionales_Articulos] FOREIGN KEY ([IdArticulo]) REFERENCES [dbo].[Articulos] ([IdArticulo]),
    CONSTRAINT [FK_ArticulosDatosAdicionales_TiposDatosAdicionales] FOREIGN KEY ([IdTipoDatoAdicional]) REFERENCES [dbo].[TiposDatosAdicionales] ([IdTipoDatoAdicional])
);

